-- ----------------------------
-- 该脚本用于删除自动生成的用户权限管理数据。在搭建初始环境的时候，不要执行该脚本。
-- 再次重新生成项目的时候，如果您在生成器中新增了用户权限相关的数据，而之前已经搭建好的数据库中，也存在了
-- 您自己手动插入的权限数据时，可以通过执行该脚本，将现有数据库表中，生成器生成的权限数据删除，删除之后，可以再执行新生成的数据库脚本数据。
-- 请仅在下面的数据库链接中执行该脚本。
-- 主数据源 [192.168.0.1:3306/db]
-- ----------------------------

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- 全部菜单数据
-- ----------------------------
BEGIN;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182095430520833;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182095438909440;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063649;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063650;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063651;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063652;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063653;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182095438909441;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063655;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063656;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063657;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063658;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182095438909442;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063662;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063663;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063664;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063665;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063666;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063667;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063668;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063669;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063670;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182095438909443;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063672;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063673;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063674;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063675;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063676;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063677;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063678;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063679;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063680;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182095438909445;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063688;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063689;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063690;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063691;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182095438909448;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063695;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063696;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063697;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063698;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063699;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182095438909449;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063701;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182095438909450;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063703;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182095438909451;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063705;
DELETE FROM `t_sys_menu` WHERE menu_id = 1981182324775063706;

-- ----------------------------
-- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `t_sys_menu` WHERE menu_id = 1634009076981567488;
DELETE FROM `t_sys_menu` WHERE menu_id = 1392786549942259712;
DELETE FROM `t_sys_menu` WHERE menu_id = 1392786950682841088;
DELETE FROM `t_sys_menu` WHERE menu_id = 1392786950682841089;
DELETE FROM `t_sys_menu` WHERE menu_id = 1392786476428693504;

-- ----------------------------
-- 以下记录用于报表打印，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `t_sys_menu` WHERE menu_id = 1534897180643430400;
DELETE FROM `t_sys_menu` WHERE menu_id = 1517063268609298432;
DELETE FROM `t_sys_menu` WHERE menu_id = 1516291375656603648;
DELETE FROM `t_sys_menu` WHERE menu_id = 1515858207237476352;
DELETE FROM `t_sys_menu` WHERE menu_id = 1515858116057501696;
DELETE FROM `t_sys_menu` WHERE menu_id = 1515857992501694464;

-- ----------------------------
-- 以下记录用于工作流，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `t_sys_menu` WHERE menu_id = 1418057714138877952;
DELETE FROM `t_sys_menu` WHERE menu_id = 1418059005175009280;
DELETE FROM `t_sys_menu` WHERE menu_id = 1418057835631087616;
DELETE FROM `t_sys_menu` WHERE menu_id = 1418057835631087617;
DELETE FROM `t_sys_menu` WHERE menu_id = 1418058289182150656;
DELETE FROM `t_sys_menu` WHERE menu_id = 1418058744037642240;
DELETE FROM `t_sys_menu` WHERE menu_id = 1418059167532322816;
DELETE FROM `t_sys_menu` WHERE menu_id = 1418059283920064512;
DELETE FROM `t_sys_menu` WHERE menu_id = 1423161217970606080;
DELETE FROM `t_sys_menu` WHERE menu_id = 1418059167532322810;
DELETE FROM `t_sys_menu` WHERE menu_id = 1418059167532322811;
DELETE FROM `t_sys_menu` WHERE menu_id = 1418059283920064515;
DELETE FROM `t_sys_menu` WHERE menu_id = 1418059283920064516;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
